Stored Procedures [dbo].[BAEOrderProductUpdate]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@OrderProductIDint4
@Titlevarchar(128)128
@Descriptionvarchar(1024)1024
@IsSuperProductbit1
@ProductCodevarchar(64)64
@SellOnWebint4
SQL Script
create procedure [dbo].[BAEOrderProductUpdate] @OrderProductID as
int,
    @Title AS varchar(128),
    @Description AS varchar(1024),
    @IsSuperProduct AS bit,
    @ProductCode AS varchar(64),
    @SellOnWeb AS int
AS
    UPDATE OrderProduct
    SET
    Title = @Title,
    Description = @Description,
    IsSuperProduct = @IsSuperProduct,
    ProductCode = @ProductCode,
    SellOnWeb = @SellOnWeb            

    WHERE OrderProductID = @OrderProductID;

GO
Uses